Run, Practice, Share: Your Interactive SQL Playground

Tags: MariaDB 11.4 MariaDB 11.5 MariaDB 10 MariaDB 10 Sakila (ReadOnly) MySQL 8.0 MySQL 8.0 Sakila (ReadOnly) MySQL 9.3.0 SQLite 3 SQLite 3 Preloaded PostgreSQL 10 Bookings (ReadOnly) PostgreSQL 13 PostgreSQL 14 PostgreSQL 15 PostgreSQL 16 PostgreSQL 17 MS SQL Server 2017 MS SQL Server 2019 MS SQL Server 2022 MS SQL Server 2022 AdventureWorks (ReadOnly) Firebird 4.0 Firebird 4.0 (Employee) Oracle Database 19c (HR) Oracle Database 21c Oracle Database 23c Free SOQOL

CREATE OR REPLACE TRIGGER - Popular snippets

Oracle Database 21c CREATE OR REPLACE TRIGGER UPDATE SELECT WHERE INSERT INTO last run: 2023-03-06 18:31:01
6
MySQL 8.0 CREATE OR REPLACE TRIGGER OR UPDATE SELECT COUNT WHERE last run: 2024-11-26 11:18:10
5
PostgreSQL 15 CREATE TABLE CREATE OR REPLACE FUNCTION UPDATE CASE CREATE OR REPLACE TRIGGER OR EXEC last run: 2024-02-23 10:47:39
5
Oracle Database 21c CREATE TABLE PRIMARY KEY NOT INSERT INTO IN EXEC MONTH AND SELECT CREATE OR REPLACE TRIGGER UPDATE OR last run: 2025-04-24 13:10:00
5
PostgreSQL 15 CREATE TABLE PRIMARY KEY OR INSERT INTO SELECT COUNT INNER JOIN WHERE IN GROUP BY ORDER BY HAVING NOT CREATE OR REPLACE FUNCTION CREATE OR REPLACE TRIGGER UPDATE EXEC last run: 2023-01-09 20:55:17
5
PostgreSQL 15 DROP TABLE CREATE TABLE INSERT INTO CREATE OR REPLACE FUNCTION OR CREATE OR REPLACE TRIGGER UPDATE EXEC WHERE SELECT last run: 2024-04-26 11:56:40
4
Oracle Database 23c Free CREATE TABLE NOT CREATE OR REPLACE TRIGGER AUTO_INCREMENT SELECT COALESCE last run: 2023-09-18 10:04:03
4
PostgreSQL 15 CREATE TABLE PRIMARY KEY NOT DEFAULT FOREIGN KEY DELETE INSERT INTO SELECT ORDER BY CREATE OR REPLACE VIEW JOIN DROP VIEW CREATE OR REPLACE PROCEDURE UPDATE WHERE AND CREATE OR REPLACE FUNCTION CREATE OR REPLACE TRIGGER EXEC last run: 2023-06-08 13:40:32
4
PostgreSQL 14 CREATE TABLE CREATE OR REPLACE FUNCTION SELECT WHERE CREATE OR REPLACE VIEW JOIN INSERT INTO CREATE OR REPLACE TRIGGER EXEC last run: 2023-04-29 21:21:22
4
PostgreSQL 14 CREATE TABLE CREATE OR REPLACE FUNCTION SELECT WHERE CREATE OR REPLACE VIEW JOIN CREATE OR REPLACE TRIGGER EXEC INSERT INTO last run: 2023-05-17 19:02:29
4

CREATE OR REPLACE TRIGGER - New snippets

MySQL 8.0 CREATE TABLE PRIMARY KEY NOT FOREIGN KEY INSERT INTO SELECT JOIN GROUP BY DEFAULT CREATE OR REPLACE TRIGGER UPDATE WHERE added at: 2025-05-08 07:22:45
1
Oracle Database 23c Free CREATE TABLE PRIMARY KEY NOT INSERT INTO CREATE OR REPLACE TRIGGER DELETE SELECT WHERE added at: 2025-04-23 21:11:45
1
Oracle Database 23c Free CREATE TABLE PRIMARY KEY NOT INSERT INTO CREATE OR REPLACE TRIGGER DELETE SELECT WHERE added at: 2025-04-23 21:11:24
1
Oracle Database 23c Free CREATE OR REPLACE TRIGGER DELETE INSERT INTO SELECT WHERE added at: 2025-04-23 21:05:19
1
Oracle Database 23c Free CREATE OR REPLACE TRIGGER DELETE INSERT INTO SELECT WHERE added at: 2025-04-23 21:05:09
2
Oracle Database 23c Free CREATE OR REPLACE TRIGGER DELETE INSERT INTO SELECT WHERE added at: 2025-04-23 21:04:46
1
Oracle Database 23c Free CREATE TABLE PRIMARY KEY NOT INSERT INTO CREATE OR REPLACE TRIGGER DELETE SELECT WHERE added at: 2025-04-23 21:03:51
1
Oracle Database 19c (HR) CREATE TABLE PRIMARY KEY NOT INSERT INTO CREATE OR REPLACE TRIGGER DELETE SELECT WHERE added at: 2025-04-23 21:02:05
2
Oracle Database 21c CREATE TABLE PRIMARY KEY NOT INSERT INTO CREATE OR REPLACE TRIGGER DELETE SELECT WHERE added at: 2025-04-23 21:00:48
1
Oracle Database 21c CREATE TABLE PRIMARY KEY NOT CONSTRAINT INSERT INTO FOREIGN KEY CREATE OR REPLACE TRIGGER WITH SUM SELECT WHERE AND ORDER BY COALESCE GROUP BY LEFT JOIN added at: 2025-03-13 12:42:54
1

SQLize.online - Popular functions

SELECT

1512k

WHERE

831k

ORDER BY

679k

CREATE TABLE

483k

JOIN

478k

INSERT INTO

431k

GROUP BY

400k

AND

365k

334k

PRIMARY KEY

312k

NOT

311k

COUNT

286k

SHOW

262k

WITH

162k

FOREIGN KEY

151k

LEFT

141k

CONSTRAINT

131k

DROP TABLE

115k

AUTO_INCREMENT

113k

INNER JOIN

112k

LENGTH

107k

101k

SUM

100k

DEFAULT

89k

HAVING

84k

UPDATE

69k

59k

BETWEEN

55k

CONCAT

43k

DELETE

41k

CASE

37k

ALTER TABLE

36k

CREATE VIEW

36k

DROP VIEW

27k

REPLACE

26k

ROW_NUMBER

25k

MONTH

24k

CREATE PROCEDURE

23k

EXEC

19k

DROP PROCEDURE

19k

RIGHT

18k

DENSE_RANK

12k

ADD CONSTRAINT

12k

COALESCE

12k

LEAD

11k

SUBSTRING

10k

LAG

10k

CROSS JOIN

OUTER JOIN

CREATE OR REPLACE FUNCTION

CREATE FUNCTION

INSERT INTO

ADD COLUMN

TRUNCATE

DAYOFWEEK

UPPER

SUBSTR

LOWER

DROP COLUMN

DESCRIBE

TRIM

INSERT INTO

LEFT JOIN

CREATE OR REPLACE VIEW

IFNULL

CREATE OR REPLACE PROCEDURE

REVERSE

JSON_ARRAY

JSON_CONTAINS

LPAD

DROP CONSTRAINT

INSERT INTO

855

ORDER BY

757

NULLIF

718

JSON_AGG

640

UUID_GENERATE_V4

626

INNER JOIN

516

INSERT INTO

437

CREATE OR REPLACE TRIGGER

436

GROUP BY

416

RTRIM

405

ADD CONSTRAINT

403

DROP FUNCTION

360

DROP INDEX

273

RPAD

262

LTRIM

226

DROP TRIGGER

192

FOREIGN KEY

178

PRIMARY KEY

153

ROW_TO_JSON

138

CREATE TABLE

132

DROP SEQUENCE

DROP PROCEDURE

ADD COLUMN

INNER JOIN

ADD CONSTRAINT

CREATE OR REPLACE FUNCTION

DROP TABLE

INSERT INTO

Like the site? Share it!

Have a questions? Ask in our telegram chat!

PHP versions: PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2, PHP 8.3, PHP 8.4
RDBMS versions: MariaDB 11.4, MariaDB 11.5, MariaDB 10, MariaDB 10 Sakila (ReadOnly), MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), MySQL 9.3.0, SQLite 3, SQLite 3 Preloaded, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, PostgreSQL 17, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, MS SQL Server 2022 AdventureWorks (ReadOnly), Firebird 4.0, Firebird 4.0 (Employee), Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 23c Free, SOQOL

SQLize Online / PHPize Online / SQLtest Online

CREATE OR REPLACE TRIGGER - Popular snippets

CREATE OR REPLACE TRIGGER - New snippets

SQLize.online - Popular functions